package com.xxgc.mybatis.dao.extend;

import com.xxgc.mybatis.entity.extend.UserAndMoney;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserAndMoneyMapper {
    //根据用户id查寻消费记录
    @Select("SELECT `u_name`,`m_type`,`m_number`,`m_payment_method`,`m_create_money` "  +
            "FROM `users`,`money`\n"  +
            "WHERE `u_id`=`m_user`\n"  +
            "AND `u_id`=#{uId}")
        List<UserAndMoney> selectByPrimaryKey(Long uId);
}
